UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HcBTxGuDUHAQj4lZ6Gc1167OKo8pNdAtwDSRGxV/gcQ='
WHERE
key_id = '48924a1b9326fa82a98d7dfb20113626df80d2ad6d3744efb61a0906c90f3f70'
AND (
token = 'HcBTxGuDUHAQj4lZ6Gc1167OKo8pNdAtwDSRGxV/gcQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)