UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hZSO2hnyyGGDcmCwLTuWJHJOVdSJlaOKdnT0SUCF4N8='
WHERE
key_id = 'e06104e50ac0eaaa1186070b6e2c766abc3f494b7a15e81398f96a6c90b1fd54'
AND (
token = 'hZSO2hnyyGGDcmCwLTuWJHJOVdSJlaOKdnT0SUCF4N8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)