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