UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/zhYoMSxD5wn2V4DYy5qgayT2K386D0J/SXzPIdBmys='
WHERE
key_id = 'db47f7858089069e3b94a27920fcc33c897d067bd4aa65b36d88adc5eb65c579'
AND (
token = '/zhYoMSxD5wn2V4DYy5qgayT2K386D0J/SXzPIdBmys='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)