UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xH2/p8e1Dd0sXYi3lhCBMIedrBAaUyKwfODQ8CRp+G8='
WHERE
key_id = '4e416c286d0fe1fd767d9f622e591783dc703acff41e413d7796de39b333526c'
AND (
token = 'xH2/p8e1Dd0sXYi3lhCBMIedrBAaUyKwfODQ8CRp+G8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)