UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '948QQHa/jZXQa8ztYlsAoWcdaZsPalqTJCd1eT5wyuU='
WHERE
key_id = '86345d7b09d4f47e373088e5d7eaae9c4e758a3adc85d40a61882e6373a7073c'
AND (
token = '948QQHa/jZXQa8ztYlsAoWcdaZsPalqTJCd1eT5wyuU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)