UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tWhG4yHk6nvRUJTF+BmPjJ3h24vyY8CTqWc2DU06PQE='
WHERE
key_id = 'a4ea0c3f7daa008bcaf11735a9f492b4aa47b228e22c9afbe23c58bc273630fc'
AND (
token = 'tWhG4yHk6nvRUJTF+BmPjJ3h24vyY8CTqWc2DU06PQE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)