UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7AMxE2JMLnDZgv4TW/Uft7nJgGfZ0sesf9CXX4B6s8g='
WHERE
key_id = '95c9844033b070156b77228e252570cfe5d3750e94f8608cd11890c0eb6d0394'
AND (
token = '7AMxE2JMLnDZgv4TW/Uft7nJgGfZ0sesf9CXX4B6s8g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)