UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n1QBHEr9YBXq0hpU7GmjnF6/NoZJ4V8WlSI5d0VQGF4='
WHERE
key_id = 'c4da1e22d6553471a0acb1b25c7a2a252ec5e9d8470f495d2135699198a00081'
AND (
token = 'n1QBHEr9YBXq0hpU7GmjnF6/NoZJ4V8WlSI5d0VQGF4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)