UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HlCAPgTTaAWU6T9hzE00WnIrDHoHtaDKOhz2zr1O2mg='
WHERE
key_id = '31dd7187c4cc5b057ff4d65bd8b2fc93d22777b13a23c2e3004eb196d19e0647'
AND (
token = 'HlCAPgTTaAWU6T9hzE00WnIrDHoHtaDKOhz2zr1O2mg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)