UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XTxoNdOozMUQqjwipJn9rpxQyyNcrKhel/8zAJB32DE='
WHERE
key_id = '306cd363c5c28282794665af603c2346d6f2ad68048e42b424e09bd952511008'
AND (
token = 'XTxoNdOozMUQqjwipJn9rpxQyyNcrKhel/8zAJB32DE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)