UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n9rHkBoYSaurYwgx3guHkP7K42CvJl3uTv3q/ilw2sU='
WHERE
key_id = '9a203c2a5a0e8362ef0ef79ddb4e387e6150f86b4d530cf9e98aa25b6b1bbeaa'
AND (
token = 'n9rHkBoYSaurYwgx3guHkP7K42CvJl3uTv3q/ilw2sU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)