UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J1DoAi9oHMRMj6bCffxPPHLnnxu3IokU9dm3BTKPzoM='
WHERE
key_id = '7e8a95f099d0a1c7644037dfe0828f8c13a5f03462491deb9eb0a273abe30285'
AND (
token = 'J1DoAi9oHMRMj6bCffxPPHLnnxu3IokU9dm3BTKPzoM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)