UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TN7Z9JmbQ0+mmHcQ6cFrUGZGHZXcc+75ePWaxH448lo='
WHERE
key_id = 'e544ad49ade36fe8486ad6d6c7ad55de9ccf511727202c224492e2a765949e84'
AND (
token = 'TN7Z9JmbQ0+mmHcQ6cFrUGZGHZXcc+75ePWaxH448lo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)