UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e9dhk72cK0lZSrMAsRyDu/YI0tPw+FG35MCiJPguqK8='
WHERE
key_id = '4b48833b450ac490690866614887c7d537afad5a9f24e4164f34e436ae1bfebe'
AND (
token = 'e9dhk72cK0lZSrMAsRyDu/YI0tPw+FG35MCiJPguqK8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)