UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Fxw7TJfP/JzrNX6OPijIUbFEqY1IGvm56MbqxJfETc='
WHERE
key_id = '8bbd1b9489f01aa8f86325694d15f0f617fef3f7b19a0c5a1eab10b52f9a92eb'
AND (
token = '3Fxw7TJfP/JzrNX6OPijIUbFEqY1IGvm56MbqxJfETc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)