UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'to8SDqExHjBtLzP0o779Q0Ybmh1h5JTntTj1DURFEv8='
WHERE
key_id = '4e878df69f34c18505c9b46649f55a0f0e76bd4e0e28afa7536d8f3d6a602939'
AND (
token = 'to8SDqExHjBtLzP0o779Q0Ybmh1h5JTntTj1DURFEv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)