UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0VaQP2HrTDMcPg4SVVjG77cCCfpdCsBFss0DQdEi1Xc='
WHERE
key_id = '59c268026e88e0bdf22a48ba77e1cf1a6062112e4d09ce51a053dccee2b39384'
AND (
token = '0VaQP2HrTDMcPg4SVVjG77cCCfpdCsBFss0DQdEi1Xc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)