UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hEG1UFxTZA+Y4gUBT7SmGGWw7rolN6O2qXaGy5hpKf4='
WHERE
key_id = 'e24ae6e305b450eab10421e8892d04f73c2668aa47dc0dfcbfff8648831587ef'
AND (
token = 'hEG1UFxTZA+Y4gUBT7SmGGWw7rolN6O2qXaGy5hpKf4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)