UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jcRvKzS6ge7tvE5r+eChdrSXt6NpiibTEFxgNXfY4rk='
WHERE
key_id = 'b8a6411e0259a13924bcda313a05fa87d05df10b01eccd3cfaa1898dbe9d63b4'
AND (
token = 'jcRvKzS6ge7tvE5r+eChdrSXt6NpiibTEFxgNXfY4rk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)