UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kM4+YdDcJduYgHe54QcEGp7QhyQeXo0rYdz3i+z1k60='
WHERE
key_id = '18f5e93823a6035c2de5a4d48463014912f8cd8869514b528f67e885d5601c2a'
AND (
token = 'kM4+YdDcJduYgHe54QcEGp7QhyQeXo0rYdz3i+z1k60='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)