UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hVyfmGwpSYwbroeg7xf4TJ71gpcKuyodCW6EHvf++ek='
WHERE
key_id = '4067b131c0ad332964d40febcd33ae15257d1975974a8f5232e9e76860554fcc'
AND (
token = 'hVyfmGwpSYwbroeg7xf4TJ71gpcKuyodCW6EHvf++ek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)