UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CNqg9o6vXwQkl01bdgV77Xyj6iRpyT9tX9SurgfSXes='
WHERE
key_id = '581a631e9adeae7c3397b2fea69ff634302af65d1fe14ad8b3bf31d7110b5ea6'
AND (
token = 'CNqg9o6vXwQkl01bdgV77Xyj6iRpyT9tX9SurgfSXes='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)