UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mAGdfClXiFN/H6MiwHcgfyHXO1on9+UL2VZFFxVpZ2Q='
WHERE
key_id = 'a9fe4e9d147b5eb3287e52209cb9abc3ebbc8003f341f2f208cfcd5aa9d37b8d'
AND (
token = 'mAGdfClXiFN/H6MiwHcgfyHXO1on9+UL2VZFFxVpZ2Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)