UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dDCTFdJtRJWFmQ3kyAVsMYWN6MHt7+u/MASnjTrRncE='
WHERE
key_id = 'b8654d110c3235fceccef7329350c684311d1bed121e16491db3e8aa44c57f03'
AND (
token = 'dDCTFdJtRJWFmQ3kyAVsMYWN6MHt7+u/MASnjTrRncE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)