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