UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lOFgjiR2HncI9N99JHaq0MwtecAe6xzS2U+RTiesMf0='
WHERE
key_id = 'c836ea25d315b23ea1082d3ea9983760e4dc738966668de641a118ebe6b47a2e'
AND (
token = 'lOFgjiR2HncI9N99JHaq0MwtecAe6xzS2U+RTiesMf0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)