UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nfLNTgN8GmRrW4rFi4NcUr5vVKTaGVHuNS9xQhwm0bM='
WHERE
key_id = 'ddc5b396207a5c7ec32f78e79497a343d92eef25285e3df04167e30faa79c758'
AND (
token = 'nfLNTgN8GmRrW4rFi4NcUr5vVKTaGVHuNS9xQhwm0bM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)