UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k8y5h974e/72U4OwCzGgVEIzNshFMKQw1y7Pd8q2TmE='
WHERE
key_id = 'b626e02ae91d4442a464025cf8a8ab0cb7bdf54b54679f13699cfe9310831855'
AND (
token = 'k8y5h974e/72U4OwCzGgVEIzNshFMKQw1y7Pd8q2TmE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)