UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5QYbTqg5JCcW6txHcXPJTdfIggC95b42HeOVn8tNqj8='
WHERE
key_id = 'f9d7d2a53f3496a806369456bc385ccea6a903887c52caf525232f43d2e617aa'
AND (
token = '5QYbTqg5JCcW6txHcXPJTdfIggC95b42HeOVn8tNqj8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)