UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AuTYXvR4moL49cfV5qcSKyJIHwX7K49gjSFYm+8a5lU='
WHERE
key_id = '8fdd60117ca34bb44ba26d4cd778a6f6b8b9b982bf71228b85c2fb44b11bed5d'
AND (
token = 'AuTYXvR4moL49cfV5qcSKyJIHwX7K49gjSFYm+8a5lU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)