UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tnYH1XL9vBtF87HqE1EgCWl3ZChZQxYP0bReVgTx9uw='
WHERE
key_id = 'c0b651af160018940430d56048e1ddc27dbc83d4271f37eb70191fe951a46331'
AND (
token = 'tnYH1XL9vBtF87HqE1EgCWl3ZChZQxYP0bReVgTx9uw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)