UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zfLQ+lMLiMdZZxik+DjsucrtIq9MtHMdlCayuUAVlio='
WHERE
key_id = '8173d967c7281172eacc68fdf7aca5e1298996996ab97e7dd6cfb288388190e8'
AND (
token = 'zfLQ+lMLiMdZZxik+DjsucrtIq9MtHMdlCayuUAVlio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)